package com.ylpms.agme.dao;

import com.ylpms.agme.entity.RegionEntity;
import com.ylpms.agme.entity.StationEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/****
 * 片区数据库操作接口
 * add by heyao 2019.01.20
 */
@Mapper
public interface RegionDao {

    @Select("select * from t_agme_region where id=#{regionid}")
    RegionEntity getRegionById(@Param("regionid") int regionid);

    @Select("select * from t_agme_region where cropcode=#{cropcode}")
    List<RegionEntity> getRegionsByCropCode(@Param("cropcode") String cropcode);

}
